/*
 Navicat Premium Data Transfer

 Source Server         : LOCALHOST
 Source Server Type    : MySQL
 Source Server Version : 50144
 Source Host           : localhost
 Source Database       : test

 Target Server Type    : MySQL
 Target Server Version : 50144
 File Encoding         : utf-8

 Date: 04/02/2011 20:35:04 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `categoria`
-- ----------------------------
DROP TABLE IF EXISTS `categoria`;
CREATE TABLE `categoria` (
  `id_categoria` int(11) NOT NULL AUTO_INCREMENT,
  `id2` int(11) NOT NULL,
  `idioma` int(11) NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `img_thumbnail` varchar(255) NOT NULL,
  PRIMARY KEY (`id_categoria`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `categoria`
-- ----------------------------
BEGIN;
INSERT INTO `categoria` VALUES ('1', '1', '1', 'category1_ES', 'uploads/2011_04_02_20_32_17_62.gif'), ('2', '1', '2', 'category1_EN', 'uploads/2011_04_02_20_32_17_62.gif'), ('3', '2', '1', 'category2_ES', 'uploads/2011_04_02_20_32_39_25.gif'), ('4', '2', '2', 'category2_EN', 'uploads/2011_04_02_20_32_39_25.gif');
COMMIT;

-- ----------------------------
--  Table structure for `proyecto`
-- ----------------------------
DROP TABLE IF EXISTS `proyecto`;
CREATE TABLE `proyecto` (
  `id_proyecto` int(11) NOT NULL AUTO_INCREMENT,
  `id2` int(11) NOT NULL,
  `idioma` int(11) NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `descripcion` text NOT NULL,
  `id_categoria` int(11) NOT NULL,
  `file_file` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  PRIMARY KEY (`id_proyecto`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `proyecto`
-- ----------------------------
BEGIN;
INSERT INTO `proyecto` VALUES ('1', '1', '1', 'project1_ES', '&nbsp;descripciÃ³n', '1', 'uploads/2011_04_02_20_34_34_61.gif', '2011-04-02'), ('2', '1', '2', 'project2_EN', '&nbsp;description', '1', 'uploads/2011_04_02_20_34_34_61.gif', '2011-04-02');
COMMIT;

-- ----------------------------
--  Table structure for `usuario`
-- ----------------------------
DROP TABLE IF EXISTS `usuario`;
CREATE TABLE `usuario` (
  `id_usuario` int(11) NOT NULL AUTO_INCREMENT,
  `id2` int(11) NOT NULL,
  `idioma` int(11) NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `login` varchar(100) NOT NULL,
  `pass` varchar(100) NOT NULL,
  PRIMARY KEY (`id_usuario`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
--  Records of `usuario`
-- ----------------------------
BEGIN;
INSERT INTO `usuario` VALUES ('1', '1', '1', 'root', 'root', 'root'), ('2', '1', '2', 'root', 'root', 'root');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
